package com.woniuxy.educationplatform.mapper;


import com.woniuxy.educationplatform.bean.SmsSignBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SmsSignMapper {

    /**
     * @author 赵扬
     * 创建时间：2020年12月9日16:26:18
     * 修改时间：2020年12月12日14:25:52
     *
     * 说明：仅仅有查询功能。查询短信签名，且只查询逻辑上没删除的（WHERE is_deleted = 0）
     *
     */

    @Results({
            @Result(id = true,property = "id",column = "id",javaType = Integer.class),
            @Result(property = "name",column = "name",javaType = String.class)
    })
    @Select(value = "SELECT id,name FROM sms_sign WHERE is_deleted = 0")
    List<SmsSignBean> selectAllSMSSign();

}
